Dataset Overview

## [1] 426057     18
##  [1] "cmte_id"           "cand_id"           "cand_nm"          
##  [4] "contbr_nm"         "contbr_city"       "contbr_st"        
##  [7] "contbr_zip"        "contbr_employer"   "contbr_occupation"
## [10] "contb_receipt_amt" "contb_receipt_dt"  "receipt_desc"     
## [13] "memo_cd"           "memo_text"         "form_tp"          
## [16] "file_num"          "tran_id"           "election_tp"
##    cmte_id               cand_id                            cand_nm      
##  Length:426057      P00003392:184378   Clinton, Hillary Rodham  :184378  
##  Class :character   P60007168: 82523   Sanders, Bernard         : 82523  
##  Mode  :character   P80001571: 78970   Trump, Donald J.         : 78970  
##                     P60006111: 29153   Cruz, Rafael Edward 'Ted': 29153  
##                     P60006723: 20472   Rubio, Marco             : 20472  
##                     P60005915: 16074   Carson, Benjamin S.      : 16074  
##                     (Other)  : 14487   (Other)                  : 14487  
##              contbr_nm        contbr_city     contbr_st  
##  LINGOR, MARGARET :   294   MIAMI   : 25317   FL:426057  
##  MCGUINNESS, DIANE:   261   TAMPA   : 14812              
##  SAIFF, IVAN      :   259   ORLANDO : 12950              
##  BAILEY, ANGELA   :   237   NAPLES  : 12577              
##  NASH, SANDY      :   218   SARASOTA: 11500              
##  STANLEY, ANTHONY :   218   (Other) :348899              
##  (Other)          :424570   NA's    :     2              
##    contbr_zip                     contbr_employer  
##  Min.   :        3   RETIRED              : 85832  
##  1st Qu.:321632264   N/A                  : 66325  
##  Median :331313214   SELF-EMPLOYED        : 29404  
##  Mean   :263365576   NONE                 : 24707  
##  3rd Qu.:336105620   INFORMATION REQUESTED: 20037  
##  Max.   :349978929   (Other)              :199488  
##  NA's   :6           NA's                 :   264  
##              contbr_occupation  contb_receipt_amt   contb_receipt_dt 
##  RETIRED              :136253   Min.   :-20000.0   12-JUL-16:  6876  
##  NOT EMPLOYED         : 33103   1st Qu.:    15.0   11-JUL-16:  6092  
##  INFORMATION REQUESTED: 19901   Median :    30.0   06-JUL-16:  3752  
##  ATTORNEY             : 10115   Mean   :   136.2   29-FEB-16:  3398  
##  PHYSICIAN            :  6071   3rd Qu.:   100.0   19-JUL-16:  3106  
##  (Other)              :220553   Max.   : 20000.0   31-OCT-16:  3097  
##  NA's                 :    61                      (Other)  :399736  
##                      receipt_desc    memo_cd   
##                            :418057    :324252  
##  Refund                    :  3720   X:101805  
##  REDESIGNATION FROM PRIMARY:   999             
##  REDESIGNATION TO GENERAL  :   998             
##  REATTRIBUTION TO SPOUSE   :   456             
##  REATTRIBUTION FROM SPOUSE :   450             
##  (Other)                   :  1377             
##                                memo_text       form_tp      
##                                     :306323   SA17A:325018  
##  * EARMARKED CONTRIBUTION: SEE BELOW: 80368   SA18 : 97319  
##  * HILLARY VICTORY FUND             : 32992   SB28A:  3720  
##  REDESIGNATION FROM PRIMARY         :   999                 
##  REDESIGNATION TO GENERAL           :   998                 
##  EARMARKED FROM MAKE DC LISTEN      :   532                 
##  (Other)                            :  3845                 
##     file_num                       tran_id       election_tp   
##  Min.   :1003942   A587D73F5F36B4479B05:     5        :  1244  
##  1st Qu.:1077916   A0C59999978424AC4931:     4   G2016:153073  
##  Median :1104813   AE049043E90AB4BB8A37:     4   O2016:    54  
##  Mean   :1100867   A59887ABCE6F64A2EB91:     3   P2016:271685  
##  3rd Qu.:1133832   AABA56134F3604F6786A:     3   P2020:     1  
##  Max.   :1146285   C11848970           :     3                 
##                    (Other)             :426035

Our dataset consists of 18 variables, with almost 426,057 observations.

Let us see some sample data

##     cmte_id   cand_id          cand_nm       contbr_nm contbr_city
## 1 C00580100 P80001571 Trump, Donald J. SELLAS, KRISTEN  CLEARWATER
## 2 C00580100 P80001571 Trump, Donald J.  SELLERS, CHRIS  VERO BEACH
##   contbr_st contbr_zip            contbr_employer
## 1        FL      33759                    RETIRED
## 2        FL      32966 PROST BEVERAGE COMPANY LLC
##             contbr_occupation contb_receipt_amt contb_receipt_dt
## 1                     RETIRED             68.37        09-NOV-16
## 2 BEVERAGE INDUSTRY EXECUTIVE             80.00        19-NOV-16
##   receipt_desc memo_cd memo_text form_tp file_num     tran_id election_tp
## 1                    X              SA18  1146165 SA18.145176       G2016
## 2                    X              SA18  1146165 SA18.120235       G2016

According FEC.gov : Individual’s contribution limit is $2700 so I’ll eliminate any negative amounts (refunds) and amounts that exceed the contribution’s limit .

## [1] 417573     18
##     cmte_id   cand_id                 cand_nm          contbr_nm
## 1 C00580100 P80001571        Trump, Donald J.    SELLAS, KRISTEN
## 2 C00580100 P80001571        Trump, Donald J.     SELLERS, CHRIS
## 3 C00575795 P00003392 Clinton, Hillary Rodham SCHECTER, MITCHELL
## 4 C00577130 P60007168        Sanders, Bernard LERBS, CHRISTOPHER
## 5 C00575795 P00003392 Clinton, Hillary Rodham       CHOREY, LORI
## 6 C00580100 P80001571        Trump, Donald J.     PUSINS, AUDREY
##          contbr_city contbr_st contbr_zip            contbr_employer
## 1         CLEARWATER        FL      33759                    RETIRED
## 2         VERO BEACH        FL      32966 PROST BEVERAGE COMPANY LLC
## 3         PLANTATION        FL  333243808                  TERRANOVA
## 4 GREEN COVE SPRINGS        FL  320433443                       NONE
## 5        TALLAHASSEE        FL  323121800      SWEAT THERAPY FITNESS
## 6         BOCA RATON        FL      33433                       PBSO
##             contbr_occupation contb_receipt_amt contb_receipt_dt
## 1                     RETIRED             68.37        09-NOV-16
## 2 BEVERAGE INDUSTRY EXECUTIVE             80.00        19-NOV-16
## 3                  CONTROLLER             15.00        22-APR-16
## 4                NOT EMPLOYED             50.00        05-MAR-16
## 5             FITNESS TRAINER            100.00        06-APR-16
## 6             LAW ENFIRCEMENY             76.89        02-DEC-16
##   receipt_desc memo_cd                           memo_text form_tp
## 1                    X                                        SA18
## 2                    X                                        SA18
## 3                    X              * HILLARY VICTORY FUND    SA18
## 4                      * EARMARKED CONTRIBUTION: SEE BELOW   SA17A
## 5                    X              * HILLARY VICTORY FUND    SA18
## 6                    X                                        SA18
##   file_num     tran_id election_tp
## 1  1146165 SA18.145176       G2016
## 2  1146165 SA18.120235       G2016
## 3  1091718    C4746745       P2016
## 4  1077404 VPF7BKX6F26       P2016
## 5  1091718    C4682258       P2016
## 6  1146165 SA18.133502       G2016

Univariate Plots Section

Exploring recieved contribution amount

##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    0.15   19.00   35.00  144.60  100.00 2700.00

From above, We can see about 120,000 contributor donated about less $145 .

Hillary clinton recieved highest contribution number with almost 190,000 contribution. Bernie sanders roughly reciedved 80,000 contribution, followed closely by Donland Trump with about 76,000 contribution.

Let’s see how much in total each of candidates recieved overall :

Hillary Clinton earned the lion’s share of recieved contribution amount among other candidates by recieving almost $22,500,000 M. What surprised me here is that Jeb Bush who had few thousands contrintuons got way a lot of money comparing to other candidates who had better contribtuiobns numbers such as Bernie sanders and Marco Rubio.

Boxplot would give us a better visulization about how recived contribtuion amount distributed across candidates :

We have a lot of outliers, Our boxplo needs some tweaks to make it more readable :

Let’s the average contribution amount for each candidates :



Now, I’m going to explore top 10 cities with most contribution number/amount :

Looking at our barchart, I was surprised that Jacksonville wasn’t the city with highest contribution number since it’s the largest city in Florida. Seeing Miami, Tampa and Orlando among the top 5 made a lot of sense. However, I was a bit shocked that Naples slightly surpassed Jacksonville. One justification I could think of is that Naples is considered of the richest cities in Florida state.


Interestingly, two small cities Naples and Boca Raton had significant contribution comparing to other large cities such as Orlando and Jacksonville.



Bivariate Plots Section

Exploring contribtuin amount and contributin date :

Let’s see how contribution is distrubted across years

I expected 2016 to have highest contribution amount mean comparing to other years, since it’s the election year and presidential race gets closer as we approach nominees announcement date. However, data proved me wrong as I clearly see 2014 has the highest contribtuon amount mean .

Let me explore election year (2016) further :



Let’s see monthly sum/mean/median of contribution amount for 2016 :




Exploring contribtuin amount and contbr_occupation :

Retireds poured a lot of moeny into the elections, marking themselves as the biggest contributors among differebt occuptaions. Way behind, comes attorneys and then homemakers in the third place.



Let us what was the mean contribtuions among those top occupations :

Homemakers were the dark horse here by contributing about $460 on avrage. Attorneys followed with average contribution less than $400



Multivariate Plots Section

Let’s look into top 10 occupations and thier impact on two final nominees, Donald Trump and Hillary Clinton

Retireds were the most highest contributor to both nominees. Attorneys played a heavy role contribtuting way much money to Hillary comapring to fractions Donlad recieved from them.

Trump has better average recived contribtuion amount than Hillary across all top 10 occupation except Attornys. Attronys donated about $400 on average to Hillary, and about $250 on average to Trump.





Final Plots and Summary

Plot One

Rich citites in Florida played major role contributing to candidates. We can see how rich, small cities liek Naples and Boca Raton have more i mpact than major cities such as Jacksonville.



Plot Two

Contributin amounts started going up somewhere aroud Septmeber, reaching the peak in October and then started decreasing toward election month, Nov.



Plot Three

Hillary topped Trump in all top 10 occuptins.





Reflection

Florida state 2016 election contribution dataset contains more than 417573 items which were captured between 2013-10-01 and 2016-12-31. To begin, I omitted contribution above FEC limit which is $2700, and any refunes.

The average contribuion was around $145, and the minimum recieved contribution was $0.15.

Most of the contribution was made to hillary clinton, bernie sanders and Donland Trump respectivly.

Contributors from Miami, Tampa and Naples contributed the major portion of recived money.

On average, contribution amount was about $300 in 2014 which was best avergae contributon comparing to other years.

Retireds, attorneys and homemakers were major players by contriuting most of the moeny recived. On average, homemakers donated about $460 and attoreys about $390 .

Candidate Benjamin carson recived the lowest contribution overall in Florida, and most of the contribution he recieved was from retireds.

It’d be very interesting to look how condidates performed in other swing states. Further, explore contribution based on the candidate’s party and his/her background.